IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[SelectAllCliente]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
	DROP PROCEDURE [dbo].[SelectAllCliente]
GO

CREATE PROCEDURE [dbo].[SelectAllCliente]

AS
BEGIN
	SET NOCOUNT ON

	SELECT
	[IdCliente],
	[UserID],
	[Dni],
	[Nombre],
	[Apellidos],
	[Ruc],
	[RazonSocial],
	[IdDistrito],
	[Direccion],
	[Email],
	[Telefono],
	[Celular],
	[FechaNacimiento],
	[Sexo],
	[Ocupacion],
	[Foto]
	FROM [Cliente]

	SET NOCOUNT OFF
END

GO
